SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].[paObtenerPlazasDeMovimiento]

@IdCola INT

AS
SET NOCOUNT ON
SET DATEFORMAT dmy
SELECT P.IdPlaza, P.CUPOF,  PM.ObligacionesADescontar  
FROM tb_PlazasDeMovimiento PM
INNER JOIN tb_Plazas P ON P.IdPlaza = PM.IdPlaza
WHERE IdCola = @IdCola
GO
GRANT EXECUTE ON  [dbo].[paObtenerPlazasDeMovimiento] TO [PersonalDocente]
GRANT EXECUTE ON  [dbo].[paObtenerPlazasDeMovimiento] TO [PersonalDocenteDireccion]
GRANT EXECUTE ON  [dbo].[paObtenerPlazasDeMovimiento] TO [SoloVer]
GO
